{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\Han\Desktop\document\불평등 연구\주제26_집과_민주주의\competition and change\data\analysis_1.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}14 Nov 2024, 13:48:12

{com}. encode country, gen(country_1)

. 
. 
. 
. tsset country_1 year
{res}{txt}{col 8}panel variable:  {res}country_1 (unbalanced)
{txt}{col 9}time variable:  {res}{col 25}year, 1996 to 2021
{txt}{col 17}delta:  {res}1 unit

{com}. 
. 
. 
. gen ln_gdp = ln( gdp_pc )

. 
. 
. 
. xtreg electoral_democracy c.house_price_to_income##c.Own_outright ln_gdp inflation interest_rate social_spending i.year, fe
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}       348
{txt}Group variable: {res}country_1{txt}{col 49}Number of groups{col 67}={col 69}{res}        33

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.3080{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.0089{col 63}{txt}avg{col 67}={col 69}{res}      10.5
{txt}     overall = {res}0.0665{col 63}{txt}max{col 67}={col 69}{res}        12

{txt}{col 49}F({res}18{txt},{res}297{txt}){col 67}={col 70}{res}     7.35
{txt}corr(u_i, Xb){col 16}= {res}-0.4769{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{hline 39}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}                   electoral_democracy{col 40}{c |}      Coef.{col 52}   Std. Err.{col 64}      t{col 72}   P>|t|{col 80}     [95% Con{col 93}f. Interval]
{hline 39}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 17}house_price_to_income {c |}{col 40}{res}{space 2} .0021801{col 52}{space 2} .0005029{col 63}{space 1}    4.33{col 72}{space 3}0.000{col 80}{space 4} .0011903{col 93}{space 3} .0031698
{txt}{space 26}Own_outright {c |}{col 40}{res}{space 2} .0006591{col 52}{space 2} .0014497{col 63}{space 1}    0.45{col 72}{space 3}0.650{col 80}{space 4}-.0021938{col 93}{space 3} .0035121
{txt}{space 38} {c |}
c.house_price_to_income#c.Own_outright {c |}{col 40}{res}{space 2}-.0000356{col 52}{space 2} .0000111{col 63}{space 1}   -3.20{col 72}{space 3}0.002{col 80}{space 4}-.0000575{col 93}{space 3}-.0000137
{txt}{space 38} {c |}
{space 32}ln_gdp {c |}{col 40}{res}{space 2}-.1116839{col 52}{space 2}  .042529{col 63}{space 1}   -2.63{col 72}{space 3}0.009{col 80}{space 4}-.1953803{col 93}{space 3}-.0279875
{txt}{space 29}inflation {c |}{col 40}{res}{space 2}-.0013543{col 52}{space 2} .0022821{col 63}{space 1}   -0.59{col 72}{space 3}0.553{col 80}{space 4}-.0058454{col 93}{space 3} .0031368
{txt}{space 25}interest_rate {c |}{col 40}{res}{space 2}-.0002167{col 52}{space 2} .0016344{col 63}{space 1}   -0.13{col 72}{space 3}0.895{col 80}{space 4}-.0034331{col 93}{space 3} .0029997
{txt}{space 23}social_spending {c |}{col 40}{res}{space 2} .0003389{col 52}{space 2} .0020727{col 63}{space 1}    0.16{col 72}{space 3}0.870{col 80}{space 4}-.0037401{col 93}{space 3} .0044179
{txt}{space 38} {c |}
{space 34}year {c |}
{space 33}2011  {c |}{col 40}{res}{space 2} .0084096{col 52}{space 2} .0093029{col 63}{space 1}    0.90{col 72}{space 3}0.367{col 80}{space 4}-.0098984{col 93}{space 3} .0267175
{txt}{space 33}2012  {c |}{col 40}{res}{space 2}  .008123{col 52}{space 2}  .009005{col 63}{space 1}    0.90{col 72}{space 3}0.368{col 80}{space 4}-.0095987{col 93}{space 3} .0258448
{txt}{space 33}2013  {c |}{col 40}{res}{space 2} .0054563{col 52}{space 2} .0100536{col 63}{space 1}    0.54{col 72}{space 3}0.588{col 80}{space 4} -.014329{col 93}{space 3} .0252415
{txt}{space 33}2014  {c |}{col 40}{res}{space 2} .0002596{col 52}{space 2} .0108579{col 63}{space 1}    0.02{col 72}{space 3}0.981{col 80}{space 4}-.0211085{col 93}{space 3} .0216277
{txt}{space 33}2015  {c |}{col 40}{res}{space 2} .0005398{col 52}{space 2} .0121515{col 63}{space 1}    0.04{col 72}{space 3}0.965{col 80}{space 4}-.0233741{col 93}{space 3} .0244537
{txt}{space 33}2016  {c |}{col 40}{res}{space 2}-.0054433{col 52}{space 2} .0133603{col 63}{space 1}   -0.41{col 72}{space 3}0.684{col 80}{space 4}-.0317362{col 93}{space 3} .0208495
{txt}{space 33}2017  {c |}{col 40}{res}{space 2}-.0030346{col 52}{space 2}  .014119{col 63}{space 1}   -0.21{col 72}{space 3}0.830{col 80}{space 4}-.0308207{col 93}{space 3} .0247514
{txt}{space 33}2018  {c |}{col 40}{res}{space 2}-.0092203{col 52}{space 2} .0153497{col 63}{space 1}   -0.60{col 72}{space 3}0.549{col 80}{space 4}-.0394283{col 93}{space 3} .0209877
{txt}{space 33}2019  {c |}{col 40}{res}{space 2}-.0096777{col 52}{space 2} .0177431{col 63}{space 1}   -0.55{col 72}{space 3}0.586{col 80}{space 4}-.0445958{col 93}{space 3} .0252404
{txt}{space 33}2020  {c |}{col 40}{res}{space 2}-.0248896{col 52}{space 2}   .02161{col 63}{space 1}   -1.15{col 72}{space 3}0.250{col 80}{space 4}-.0674178{col 93}{space 3} .0176387
{txt}{space 33}2021  {c |}{col 40}{res}{space 2}-.0274871{col 52}{space 2} .0228771{col 63}{space 1}   -1.20{col 72}{space 3}0.231{col 80}{space 4}-.0725088{col 93}{space 3} .0175346
{txt}{space 38} {c |}
{space 33}_cons {c |}{col 40}{res}{space 2} 1.936032{col 52}{space 2} .4907034{col 63}{space 1}    3.95{col 72}{space 3}0.000{col 80}{space 4} .9703358{col 93}{space 3} 2.901728
{txt}{hline 39}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                               sigma_u {c |} {res}  .0788955
                               {txt}sigma_e {c |} {res} .03346406
                                   {txt}rho {c |} {res} .84752304{txt}   (fraction of variance due to u_i)
{hline 39}{c BT}{hline 64}
F test that all u_i=0: F({res}32{txt}, {res}297{txt}) = {res}19.48{col 62}{txt}Prob > F = {res}0.0000

{com}. 
. estimates store model_1

. 
. 
. 
. 
. 
. xtreg electoral_democracy c.house_price_to_income##c.Owner_with_mortgage ln_gdp inflation interest_rate social_spending i.year, fe
{res}
{txt}Fixed-effects (within) regression{col 49}Number of obs{col 67}={col 69}{res}       348
{txt}Group variable: {res}country_1{txt}{col 49}Number of groups{col 67}={col 69}{res}        33

{txt}R-sq:{col 49}Obs per group:
     within  = {res}0.2882{col 63}{txt}min{col 67}={col 69}{res}         1
{txt}     between = {res}0.0020{col 63}{txt}avg{col 67}={col 69}{res}      10.5
{txt}     overall = {res}0.0212{col 63}{txt}max{col 67}={col 69}{res}        12

{txt}{col 49}F({res}18{txt},{res}297{txt}){col 67}={col 70}{res}     6.68
{txt}corr(u_i, Xb){col 16}= {res}-0.3279{txt}{col 49}Prob > F{col 67}={col 73}{res}0.0000

{txt}{hline 46}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1}                          electoral_democracy{col 47}{c |}      Coef.{col 59}   Std. Err.{col 71}      t{col 79}   P>|t|{col 87}     [95% Con{col 100}f. Interval]
{hline 46}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 24}house_price_to_income {c |}{col 47}{res}{space 2}-.0005579{col 59}{space 2} .0005402{col 70}{space 1}   -1.03{col 79}{space 3}0.303{col 87}{space 4}-.0016209{col 100}{space 3} .0005052
{txt}{space 26}Owner_with_mortgage {c |}{col 47}{res}{space 2}-.0024689{col 59}{space 2} .0017052{col 70}{space 1}   -1.45{col 79}{space 3}0.149{col 87}{space 4}-.0058247{col 100}{space 3} .0008869
{txt}{space 45} {c |}
c.house_price_to_income#c.Owner_with_mortgage {c |}{col 47}{res}{space 2} .0000439{col 59}{space 2} .0000154{col 70}{space 1}    2.85{col 79}{space 3}0.005{col 87}{space 4} .0000136{col 100}{space 3} .0000742
{txt}{space 45} {c |}
{space 39}ln_gdp {c |}{col 47}{res}{space 2}-.0964623{col 59}{space 2}  .043685{col 70}{space 1}   -2.21{col 79}{space 3}0.028{col 87}{space 4}-.1824337{col 100}{space 3}-.0104909
{txt}{space 36}inflation {c |}{col 47}{res}{space 2} -.001932{col 59}{space 2} .0022966{col 70}{space 1}   -0.84{col 79}{space 3}0.401{col 87}{space 4}-.0064517{col 100}{space 3} .0025877
{txt}{space 32}interest_rate {c |}{col 47}{res}{space 2}-.0003825{col 59}{space 2} .0016515{col 70}{space 1}   -0.23{col 79}{space 3}0.817{col 87}{space 4}-.0036327{col 100}{space 3} .0028677
{txt}{space 30}social_spending {c |}{col 47}{res}{space 2} .0014113{col 59}{space 2} .0021125{col 70}{space 1}    0.67{col 79}{space 3}0.505{col 87}{space 4}-.0027461{col 100}{space 3} .0055688
{txt}{space 45} {c |}
{space 41}year {c |}
{space 40}2011  {c |}{col 47}{res}{space 2} .0099773{col 59}{space 2} .0094699{col 70}{space 1}    1.05{col 79}{space 3}0.293{col 87}{space 4}-.0086593{col 100}{space 3} .0286139
{txt}{space 40}2012  {c |}{col 47}{res}{space 2} .0097129{col 59}{space 2} .0091786{col 70}{space 1}    1.06{col 79}{space 3}0.291{col 87}{space 4}-.0083504{col 100}{space 3} .0277763
{txt}{space 40}2013  {c |}{col 47}{res}{space 2} .0058986{col 59}{space 2} .0102167{col 70}{space 1}    0.58{col 79}{space 3}0.564{col 87}{space 4}-.0142077{col 100}{space 3}  .026005
{txt}{space 40}2014  {c |}{col 47}{res}{space 2} .0007017{col 59}{space 2} .0110972{col 70}{space 1}    0.06{col 79}{space 3}0.950{col 87}{space 4}-.0211374{col 100}{space 3} .0225407
{txt}{space 40}2015  {c |}{col 47}{res}{space 2} .0016472{col 59}{space 2} .0124864{col 70}{space 1}    0.13{col 79}{space 3}0.895{col 87}{space 4}-.0229258{col 100}{space 3} .0262203
{txt}{space 40}2016  {c |}{col 47}{res}{space 2}-.0054737{col 59}{space 2} .0137646{col 70}{space 1}   -0.40{col 79}{space 3}0.691{col 87}{space 4}-.0325623{col 100}{space 3} .0216148
{txt}{space 40}2017  {c |}{col 47}{res}{space 2}-.0026724{col 59}{space 2}  .014597{col 70}{space 1}   -0.18{col 79}{space 3}0.855{col 87}{space 4}-.0313991{col 100}{space 3} .0260544
{txt}{space 40}2018  {c |}{col 47}{res}{space 2}-.0084324{col 59}{space 2} .0159071{col 70}{space 1}   -0.53{col 79}{space 3}0.596{col 87}{space 4}-.0397373{col 100}{space 3} .0228724
{txt}{space 40}2019  {c |}{col 47}{res}{space 2}-.0098073{col 59}{space 2} .0184068{col 70}{space 1}   -0.53{col 79}{space 3}0.595{col 87}{space 4}-.0460316{col 100}{space 3}  .026417
{txt}{space 40}2020  {c |}{col 47}{res}{space 2}-.0288925{col 59}{space 2} .0222963{col 70}{space 1}   -1.30{col 79}{space 3}0.196{col 87}{space 4}-.0727713{col 100}{space 3} .0149862
{txt}{space 40}2021  {c |}{col 47}{res}{space 2}-.0311611{col 59}{space 2} .0235639{col 70}{space 1}   -1.32{col 79}{space 3}0.187{col 87}{space 4}-.0775344{col 100}{space 3} .0152121
{txt}{space 45} {c |}
{space 40}_cons {c |}{col 47}{res}{space 2}  1.84822{col 59}{space 2} .4837864{col 70}{space 1}    3.82{col 79}{space 3}0.000{col 87}{space 4} .8961364{col 100}{space 3} 2.800304
{txt}{hline 46}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
                                      sigma_u {c |} {res} .07180297
                                      {txt}sigma_e {c |} {res} .03393933
                                          {txt}rho {c |} {res} .81738094{txt}   (fraction of variance due to u_i)
{hline 46}{c BT}{hline 64}
F test that all u_i=0: F({res}32{txt}, {res}297{txt}) = {res}18.89{col 62}{txt}Prob > F = {res}0.0000

{com}. 
. estimates store model_2

. 
. 
. 
. 
. 
. coefplot (model_1), bylabel ((a) Own outright) || (model_2), bylabel ((b) Owner with mortgage) ||, omitted xline(0, lcolor(black) lwidth(thin)) lpattern(dash) graphregion(fcolor(white)) mlabel format(%9.5f) mlabposition(8) mlabsize(tiny) level(95 90) ciopts(lwidth(*0.5 *2))  keep(c.house_price_to_income#c.Own_outright || c.house_price_to_income#c.Owner_with_mortgage)
{res}
{com}. interflex electoral_democracy Own_outright house_price_to_income ln_gdp inflation interest_rate social_spending , ylab(Democracy) dlab(Own outright) xlab(House price to income) fe( country year )
{res}Fixed effects included; clustered standard errors highly recommended
{txt}p value of Wald test: {res}0.9582

{com}. 
. 
. 
. interflex electoral_democracy Owner_with_mortgage house_price_to_income ln_gdp inflation interest_rate social_spending, ylab(Democracy) dlab(Owner with mortage) xlab(House price to income) fe( country year )
{res}Fixed effects included; clustered standard errors highly recommended
{txt}p value of Wald test: {res}0.8277

{com}. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\Han\Desktop\document\불평등 연구\주제26_집과_민주주의\competition and change\data\analysis_1.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}14 Nov 2024, 13:49:26
{txt}{.-}
{smcl}
{txt}{sf}{ul off}